Tasks > DB2i Storage Engine

DB2i storage engine

Installing the DB2i storage engine

The DB2i extension allows you to work with tables on your local DB2 instance as if they were regular mysql tables. Before first use it must be enabled using the instructions below. After you create your first db2i table it will stay enabled (no need to modify configuration files).

 

  1. Open your mysql client f.e (/usr/local/mariadb/bin/mysql -u root)
  2. Run the command “install plugin ibmdb2i soname "ha_ibmdb2i.so";”

Further information and detailed usage instructions can be found in IBM’s RedBook “Using DB2 for i as a Storage Engine of Mysql”  :http://www.redbooks.ibm.com/abstracts/sg247705.html